package cc.mrbird.febs.accounting.mapper;

import cc.mrbird.febs.accounting.dto.standardSub.SingleExportDTO;
import cc.mrbird.febs.accounting.dto.standardSub.StandardSubDTO;
import cc.mrbird.febs.accounting.entity.StandardSub;
import cc.mrbird.febs.accounting.dto.standardSub.SubMainDetailDTO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 标准明细科目表 Mapper
 *
 * @author baoyinlei
 * @date 2021-11-29 16:39:25
 */
public interface StandardSubMapper extends BaseMapper<StandardSub> {

    List<SubMainDetailDTO> querySubMainDetail();

    List<SubMainDetailDTO> queryAllSubDetail(@Param("companyId") Long companyId,
                                             @Param("projectId") Long projectId,
                                             @Param("yearMonths") List<String> yearMonths);

    List<SubMainDetailDTO> queryAllSubDetailNoCompany(@Param("projectId") Long projectId,
                                             @Param("yearMonths") List<String> yearMonths);

    List<SingleExportDTO> querySubMainStandard(@Param("projectId") Long projectId, @Param("yearMonths") List<String> yearMonths);

    /*
     * @Author HBH
     * @Description 获取统计总览科目
     * @Date 2022/4/1
     **/
    List<StandardSub> getStatisticsStandard();

    /*
     * @Author HBH
     * @Description 获取统计明细科目
     * @Date 2022/4/1
     **/
    List<StandardSubDTO> getDetailStatisticsStandard(@Param("projectIds") List<String> projectIds, @Param("mainName") String mainName);
}
